﻿CREATE VIEW [acms].[SiteVersion_View]
AS 
	select Distinct a.SiteId, b.PublishDate as Change
	FROM [acms].[Post_View] a
		inner join [acms].[PostPositions] b on a.Id = b.PostId
	

;